package com.nuhu.dao;

import com.nuhu.pojo.Package;
import com.nuhu.pojo.User;
import com.nuhu.pojo.Worker;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface AdminPackageDao {

    @Select("select * from users ORDER BY (select count(*) from users order by users.Package_ID) DESC ")
    List<User> getPackage(int offset, int size);


    @Select("select * from package where Package_ID = #{packageId}")
    Package getPackageInformation(String packageId);
}
